--czyszczenie
DELETE FROM raw_property WHERE source = '';
DELETE FROM raw_property WHERE datetime = '';
DELETE FROM raw_property WHERE type = '';
DELETE FROM raw_property WHERE price < 100;
DELETE FROM raw_property WHERE country = '';
DELETE FROM raw_property WHERE country NOT IN ('spain', 'bulgaria', 'greece', 'portugal', 'italy', 'turkey', 'france', 'hungary', 'croatia', 'romania', 'poland', 'cyprus', 'czech republic', 'latvia', 'slovenia', 'slovakia', 'malta', 'germany', 'ukraine', 'lithuania', 'yugoslavia', 'montenegro', 'albania', 'austria', 'russia', 'sweden', 'macedonia', 'belgium', 'estonia', 'switzerland', 'bosnia and herzegovina', 'netherlands', 'finland', 'moldova', 'serbia', 'ireland', 'norway', 'united kingdom', 'andorra', 'luxembourg', 'iceland', 'denmark', 'belarus', 'san marino', 'liechtenstein', 'gibraltar');
UPDATE raw_property SET city = '' WHERE city LIKE '%[0-9]%' or LEN(city) > 30 or city = '-';